CREATE VIEW [dbo].[vContactReport]
AS
/****************************************************************************************
** This view provides basic information about each Contact on "One Row per Contact" basis.
** This view can be used as the basis for other detailed Contact related views.
**
***************************************************************************************/

SELECT          
    CM.ID as ContactId,  CM.FullName as ContactName,  CM.SortName as ContactSortName,
    CM.IsInstitute,  CSR.ContactStatusDesc as ContactStatus,  CM.TaxIDNumber,
    CM.NoSolicitationFlag,  CM.PreferredAddressCategoryCode, CM.ContactKey, CM.PrimaryMembershipGroupKey,     CM.ContactTypeKey
FROM
    ContactMain CM
    INNER JOIN    ContactStatusRef    CSR    ON    CM.ContactStatusCode = CSR.ContactStatusCode

GO